let server = require("express")();
let mysql = require("mysql");

server.all("*",function(req,res,next){
    //设置允许跨域的域名，*代表允许任意域名跨域
    res.header("Access-Control-Allow-Origin","*");
    //允许的header类型
    res.header("Access-Control-Allow-Headers","content-type");
    //跨域允许的请求方式 
    res.header("Access-Control-Allow-Methods","DELETE,PUT,POST,GET,OPTIONS");
    if (req.method.toLowerCase() == 'options')
        res.send(200);  //让options尝试请求快速结束
    else
        next();
})

let sql = mysql.createConnection({
	host       : 'localhost',
	user       : 'root',
	port       : '3307',
	password   : '123456',
	database   : 'mybatis'
});

sql.connect();

server.get("/register",function(request,response){
    let username = request.query.username;
    let password = request.query.password;
    sql.query(`insert into algin (username,password) values("${username}","${password}")`,function(error,data){
        if(error){
            console.log(error);
            response.end("error");
            return;
        }
        response.end("success");
        console.log("提交成功");
    })
})

server.get("/login",function(request,response){
    let username = request.query.username;
    let password = request.query.password;
    sql.query(`select password from algin where username="${username}"`,function(error,data){
       if(error){
        console.log(error);
        response.end("error");
        return;
       }
        else if(data.length === 0 && data.length > 1 && data[0] !== password) {
            response.end("cuo");
            return;
        }
        else{
            response.end("success");
            console.log("登录成功");
        }

    })
})
server.listen(81);
console.log("loginServer is runimg at 81");